Problem Note 38731: Errors might occur when you run the rpo_alert task of the back-end jobs in SAS® Regular Price Optimization
 |  |  |  |  |
You might encounter an error similar to the following in the log when you run the rpo_alert task of back-end jobs in SAS Regular Price Optimization:
ERROR: During insert: [IBM][CLI Driver][DB2/AIX64] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "DI_DM.MARGIN_RULE_VIOLATION" from having duplicate values for the index key. SQLSTATE=23505
This error occurs when the value of the NUM_PARALLEL_EXECUTIONS spec in the GLOBAL_SETTING table is greater than or equal to 10.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Regular Price Optimization | Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 3.2 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
A fix for this issue for SAS Merchandise Intelligence 3.2 is available at:
http://www.sas.com/techsup/download/hotfix/ro32.html#038731| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2010-02-15 20:55:30 |
| Date Created: | 2010-02-15 14:53:51 |